﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsCartera" targetNamespace="http://tempuri.org/dsCartera.xsd" xmlns:mstns="http://tempuri.org/dsCartera.xsd" xmlns="http://tempuri.org/dsCartera.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="3" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString1 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_CONCEPTOPAGOTableAdapter" GeneratorDataComponentClassName="CAR_CONCEPTOPAGOTableAdapter" Name="CAR_CONCEPTOPAGO" UserDataComponentName="CAR_CONCEPTOPAGOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_CONCEPTOPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAR_CONCEPTOPAGO" WHERE (("IDCONCEPTO" = :Original_IDCONCEPTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_IDSUBCLASE = 1 AND "IDSUBCLASE" IS NULL) OR ("IDSUBCLASE" = :Original_IDSUBCLASE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCONCEPTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSUBCLASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDSUBCLASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAR_CONCEPTOPAGO" ("IDCONCEPTO", "DESCRIPCION", "IDSUBCLASE") VALUES (:IDCONCEPTO, :DESCRIPCION, :IDSUBCLASE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCONCEPTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDSUBCLASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCONCEPTO, DESCRIPCION, IDSUBCLASE FROM SAMUEL.CAR_CONCEPTOPAGO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAR_CONCEPTOPAGO" SET "IDCONCEPTO" = :IDCONCEPTO, "DESCRIPCION" = :DESCRIPCION, "IDSUBCLASE" = :IDSUBCLASE WHERE (("IDCONCEPTO" = :Original_IDCONCEPTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_IDSUBCLASE = 1 AND "IDSUBCLASE" IS NULL) OR ("IDSUBCLASE" = :Original_IDSUBCLASE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCONCEPTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDSUBCLASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCONCEPTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSUBCLASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDSUBCLASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCONCEPTO" DataSetColumn="IDCONCEPTO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="IDSUBCLASE" DataSetColumn="IDSUBCLASE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_CONCEPTOPAGO" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetIdSubClase" Modifier="Public" Name="GetIdSubClase" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetIdSubClase">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDCONCEPTO
FROM         CAR_CONCEPTOPAGO
WHERE     (IDSUBCLASE = :PIDSUBCLASE)
GROUP BY IDCONCEPTO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDSUBCLASE" ColumnName="IDSUBCLASE" DataSourceName="SAMUEL.CAR_CONCEPTOPAGO" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PIDSUBCLASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDSUBCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_CARTERATableAdapter" GeneratorDataComponentClassName="CAR_CARTERATableAdapter" Name="CAR_CARTERA" UserDataComponentName="CAR_CARTERATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_CARTERA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAR_CARTERA" WHERE (("IDCLIENTE" = :Original_IDCLIENTE) AND ("PERIODO" = :Original_PERIODO) AND ((:IsNull_COMPRAS = 1 AND "COMPRAS" IS NULL) OR ("COMPRAS" = :Original_COMPRAS)) AND ((:IsNull_DEVOLUCIONES = 1 AND "DEVOLUCIONES" IS NULL) OR ("DEVOLUCIONES" = :Original_DEVOLUCIONES)) AND ((:IsNull_PAGOS = 1 AND "PAGOS" IS NULL) OR ("PAGOS" = :Original_PAGOS)) AND ((:IsNull_SALDOINICIAL = 1 AND "SALDOINICIAL" IS NULL) OR ("SALDOINICIAL" = :Original_SALDOINICIAL)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMPRAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COMPRAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COMPRAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DEVOLUCIONES" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DEVOLUCIONES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DEVOLUCIONES" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DEVOLUCIONES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PAGOS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PAGOS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PAGOS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDOINICIAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAR_CARTERA" ("IDCLIENTE", "PERIODO", "COMPRAS", "DEVOLUCIONES", "PAGOS", "SALDOINICIAL") VALUES (:IDCLIENTE, :PERIODO, :COMPRAS, :DEVOLUCIONES, :PAGOS, :SALDOINICIAL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COMPRAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DEVOLUCIONES" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DEVOLUCIONES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PAGOS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCLIENTE, PERIODO, COMPRAS, DEVOLUCIONES, PAGOS, SALDOINICIAL FROM SAMUEL.CAR_CARTERA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAR_CARTERA" SET "IDCLIENTE" = :IDCLIENTE, "PERIODO" = :PERIODO, "COMPRAS" = :COMPRAS, "DEVOLUCIONES" = :DEVOLUCIONES, "PAGOS" = :PAGOS, "SALDOINICIAL" = :SALDOINICIAL WHERE (("IDCLIENTE" = :Original_IDCLIENTE) AND ("PERIODO" = :Original_PERIODO) AND ((:IsNull_COMPRAS = 1 AND "COMPRAS" IS NULL) OR ("COMPRAS" = :Original_COMPRAS)) AND ((:IsNull_DEVOLUCIONES = 1 AND "DEVOLUCIONES" IS NULL) OR ("DEVOLUCIONES" = :Original_DEVOLUCIONES)) AND ((:IsNull_PAGOS = 1 AND "PAGOS" IS NULL) OR ("PAGOS" = :Original_PAGOS)) AND ((:IsNull_SALDOINICIAL = 1 AND "SALDOINICIAL" IS NULL) OR ("SALDOINICIAL" = :Original_SALDOINICIAL)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COMPRAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DEVOLUCIONES" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DEVOLUCIONES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PAGOS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMPRAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COMPRAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COMPRAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DEVOLUCIONES" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DEVOLUCIONES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DEVOLUCIONES" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DEVOLUCIONES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PAGOS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PAGOS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PAGOS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDOINICIAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCLIENTE" DataSetColumn="IDCLIENTE" />
              <Mapping SourceColumn="PERIODO" DataSetColumn="PERIODO" />
              <Mapping SourceColumn="COMPRAS" DataSetColumn="COMPRAS" />
              <Mapping SourceColumn="DEVOLUCIONES" DataSetColumn="DEVOLUCIONES" />
              <Mapping SourceColumn="PAGOS" DataSetColumn="PAGOS" />
              <Mapping SourceColumn="SALDOINICIAL" DataSetColumn="SALDOINICIAL" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_TIPOPAGOTableAdapter" GeneratorDataComponentClassName="CAR_TIPOPAGOTableAdapter" Name="CAR_TIPOPAGO" UserDataComponentName="CAR_TIPOPAGOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_TIPOPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAR_TIPOPAGO" WHERE (("IDTIPOPAGO" = :Original_IDTIPOPAGO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAR_TIPOPAGO" ("IDTIPOPAGO", "DESCRIPCION") VALUES (:IDTIPOPAGO, :DESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTIPOPAGO, DESCRIPCION FROM SAMUEL.CAR_TIPOPAGO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAR_TIPOPAGO" SET "IDTIPOPAGO" = :IDTIPOPAGO, "DESCRIPCION" = :DESCRIPCION WHERE (("IDTIPOPAGO" = :Original_IDTIPOPAGO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTIPOPAGO" DataSetColumn="IDTIPOPAGO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_FORMASPAGOTableAdapter" GeneratorDataComponentClassName="CAR_FORMASPAGOTableAdapter" Name="CAR_FORMASPAGO" UserDataComponentName="CAR_FORMASPAGOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_FORMASPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "CAR_FORMASPAGO" WHERE (("IDFORMAPAGO" = :Original_IDFORMAPAGO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_NDIAS = 1 AND "NDIAS" IS NULL) OR ("NDIAS" = :Original_NDIAS)) AND ((:IsNull_DESCUENTO = 1 AND "DESCUENTO" IS NULL) OR ("DESCUENTO" = :Original_DESCUENTO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NDIAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NDIAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NDIAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NDIAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "CAR_FORMASPAGO" ("IDFORMAPAGO", "DESCRIPCION", "NDIAS", "DESCUENTO") VALUES (:IDFORMAPAGO, :DESCRIPCION, :NDIAS, :DESCUENTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NDIAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NDIAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDFORMAPAGO, DESCRIPCION, NDIAS, DESCUENTO
FROM         CAR_FORMASPAGO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "CAR_FORMASPAGO" SET "IDFORMAPAGO" = :IDFORMAPAGO, "DESCRIPCION" = :DESCRIPCION, "NDIAS" = :NDIAS, "DESCUENTO" = :DESCUENTO WHERE (("IDFORMAPAGO" = :Original_IDFORMAPAGO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_NDIAS = 1 AND "NDIAS" IS NULL) OR ("NDIAS" = :Original_NDIAS)) AND ((:IsNull_DESCUENTO = 1 AND "DESCUENTO" IS NULL) OR ("DESCUENTO" = :Original_DESCUENTO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NDIAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NDIAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NDIAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NDIAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NDIAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NDIAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDFORMAPAGO" DataSetColumn="IDFORMAPAGO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="NDIAS" DataSetColumn="NDIAS" />
              <Mapping SourceColumn="DESCUENTO" DataSetColumn="DESCUENTO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_FORMASPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdFormaPago" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdFormaPago" GeneratorSourceName="FillByIdFormaPago" GetMethodModifier="Public" GetMethodName="GetDataByIdFormaPago" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdFormaPago" UserSourceName="FillByIdFormaPago">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DESCRIPCION, DESCUENTO, IDFORMAPAGO, NDIAS FROM CAR_FORMASPAGO WHERE (IDFORMAPAGO = :PIDFORMAPAGO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDFORMAPAGO" ColumnName="IDFORMAPAGO" DataSourceName="SAMUEL.CAR_FORMASPAGO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_FORMASPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLikeFP" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLikeFP" GeneratorSourceName="FillByLikeFP" GetMethodModifier="Public" GetMethodName="GetDataByLikeFP" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLikeFP" UserSourceName="FillByLikeFP">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DESCRIPCION, DESCUENTO, IDFORMAPAGO, NDIAS FROM CAR_FORMASPAGO WHERE (DESCRIPCION LIKE :PDESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESCRIPCION" ColumnName="DESCRIPCION" DataSourceName="SAMUEL.CAR_FORMASPAGO" DataTypeServer="VARCHAR2(30)" DbType="String" Direction="Input" ParameterName=":PDESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_FORMASPAGO" DbObjectType="Table" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="GetDescripcionFormaPago" Modifier="Public" Name="GetDescripcionFormaPago" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetDescripcionFormaPago">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            CAR_FORMASPAGO
WHERE        (IDFORMAPAGO = :PIDFP)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDFP" ColumnName="IDFORMAPAGO" DataSourceName="SAMUEL.CAR_FORMASPAGO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDFP" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_RECIBOCAJADETALLEPLANTableAdapter" GeneratorDataComponentClassName="CAR_RECIBOCAJADETALLEPLANTableAdapter" Name="CAR_RECIBOCAJADETALLEPLAN" UserDataComponentName="CAR_RECIBOCAJADETALLEPLANTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOCAJADETALLEPLAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAR_RECIBOCAJADETALLEPLAN" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDPLAN = 1 AND "IDPLAN" IS NULL) OR ("IDPLAN" = :Original_IDPLAN)) AND ((:IsNull_VALORPLAN = 1 AND "VALORPLAN" IS NULL) OR ("VALORPLAN" = :Original_VALORPLAN)) AND ((:IsNull_IMEI = 1 AND "IMEI" IS NULL) OR ("IMEI" = :Original_IMEI)) AND ((:IsNull_ICCID = 1 AND "ICCID" IS NULL) OR ("ICCID" = :Original_ICCID)) AND ((:IsNull_MIN = 1 AND "MIN" IS NULL) OR ("MIN" = :Original_MIN)) AND ("NITEM" = :Original_NITEM))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPLAN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPLAN" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPLAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPLAN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IMEI" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICCID" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MIN" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="MIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_MIN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAR_RECIBOCAJADETALLEPLAN" ("IDDOCUMENTO", "NUMERO", "IDPLAN", "VALORPLAN", "IMEI", "ICCID", "MIN", "NITEM") VALUES (:IDDOCUMENTO, :NUMERO, :IDPLAN, :VALORPLAN, :IMEI, :ICCID, :MIN, :NITEM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPLAN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MIN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, IDPLAN, VALORPLAN, IMEI, ICCID, "MIN", NITEM FROM SAMUEL.CAR_RECIBOCAJADETALLEPLAN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAR_RECIBOCAJADETALLEPLAN" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "IDPLAN" = :IDPLAN, "VALORPLAN" = :VALORPLAN, "IMEI" = :IMEI, "ICCID" = :ICCID, "MIN" = :MIN, "NITEM" = :NITEM WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDPLAN = 1 AND "IDPLAN" IS NULL) OR ("IDPLAN" = :Original_IDPLAN)) AND ((:IsNull_VALORPLAN = 1 AND "VALORPLAN" IS NULL) OR ("VALORPLAN" = :Original_VALORPLAN)) AND ((:IsNull_IMEI = 1 AND "IMEI" IS NULL) OR ("IMEI" = :Original_IMEI)) AND ((:IsNull_ICCID = 1 AND "ICCID" IS NULL) OR ("ICCID" = :Original_ICCID)) AND ((:IsNull_MIN = 1 AND "MIN" IS NULL) OR ("MIN" = :Original_MIN)) AND ("NITEM" = :Original_NITEM))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPLAN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MIN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPLAN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPLAN" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPLAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPLAN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IMEI" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICCID" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MIN" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="MIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_MIN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="IDPLAN" DataSetColumn="IDPLAN" />
              <Mapping SourceColumn="VALORPLAN" DataSetColumn="VALORPLAN" />
              <Mapping SourceColumn="IMEI" DataSetColumn="IMEI" />
              <Mapping SourceColumn="ICCID" DataSetColumn="ICCID" />
              <Mapping SourceColumn="MIN" DataSetColumn="MIN" />
              <Mapping SourceColumn="NITEM" DataSetColumn="NITEM" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOCAJADETALLEPLAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumento" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumento" GeneratorSourceName="FillByIdDocumento" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumento" UserSourceName="FillByIdDocumento">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, IDPLAN, VALORPLAN, IMEI, ICCID, "MIN", NITEM FROM SAMUEL.CAR_RECIBOCAJADETALLEPLAN
WHERE IDDOCUMENTO=:PTIPODOC AND NUMERO=:PNUMERO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PTIPODOC" ColumnName="IDDOCUMENTO" DataSourceName="SAMUEL.CAR_RECIBOCAJADETALLEPLAN" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PTIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.CAR_RECIBOCAJADETALLEPLAN" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_RECIBOSCAJATableAdapter" GeneratorDataComponentClassName="CAR_RECIBOSCAJATableAdapter" Name="CAR_RECIBOSCAJA" UserDataComponentName="CAR_RECIBOSCAJATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOSCAJA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "CAR_RECIBOSCAJA" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDTERCERO = 1 AND "IDTERCERO" IS NULL) OR ("IDTERCERO" = :Original_IDTERCERO)) AND ((:IsNull_IDTIPOPAGO = 1 AND "IDTIPOPAGO" IS NULL) OR ("IDTIPOPAGO" = :Original_IDTIPOPAGO)) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_VALORRECIBO = 1 AND "VALORRECIBO" IS NULL) OR ("VALORRECIBO" = :Original_VALORRECIBO)) AND ((:IsNull_NOTA = 1 AND "NOTA" IS NULL) OR ("NOTA" = :Original_NOTA)) AND ((:IsNull_SUCURSAL = 1 AND "SUCURSAL" IS NULL) OR ("SUCURSAL" = :Original_SUCURSAL)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)) AND ((:IsNull_IDMEDIOPAGO = 1 AND "IDMEDIOPAGO" IS NULL) OR ("IDMEDIOPAGO" = :Original_IDMEDIOPAGO)) AND ((:IsNull_NUMEROMEDIO = 1 AND "NUMEROMEDIO" IS NULL) OR ("NUMEROMEDIO" = :Original_NUMEROMEDIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTERCERO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORRECIBO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORRECIBO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORRECIBO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRECIBO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA" Precision="0" ProviderType="Int32" Scale="0" Size="120" SourceColumn="NOTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="120" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMEDIOPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMEDIOPAGO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROMEDIO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "CAR_RECIBOSCAJA" ("IDDOCUMENTO", "NUMERO", "IDTERCERO", "IDTIPOPAGO", "FECHA", "VALORRECIBO", "NOTA", "SUCURSAL", "IDCAJA", "IDMEDIOPAGO", "NUMEROMEDIO") VALUES (:IDDOCUMENTO, :NUMERO, :IDTERCERO, :IDTIPOPAGO, :FECHA, :VALORRECIBO, :NOTA, :SUCURSAL, :IDCAJA, :IDMEDIOPAGO, :NUMEROMEDIO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORRECIBO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRECIBO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="120" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMEDIOPAGO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROMEDIO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, IDTERCERO, IDTIPOPAGO, FECHA, VALORRECIBO, NOTA, SUCURSAL, IDCAJA, IDMEDIOPAGO, NUMEROMEDIO
FROM            CAR_RECIBOSCAJA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "CAR_RECIBOSCAJA" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "IDTERCERO" = :IDTERCERO, "IDTIPOPAGO" = :IDTIPOPAGO, "FECHA" = :FECHA, "VALORRECIBO" = :VALORRECIBO, "NOTA" = :NOTA, "SUCURSAL" = :SUCURSAL, "IDCAJA" = :IDCAJA, "IDMEDIOPAGO" = :IDMEDIOPAGO, "NUMEROMEDIO" = :NUMEROMEDIO WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDTERCERO = 1 AND "IDTERCERO" IS NULL) OR ("IDTERCERO" = :Original_IDTERCERO)) AND ((:IsNull_IDTIPOPAGO = 1 AND "IDTIPOPAGO" IS NULL) OR ("IDTIPOPAGO" = :Original_IDTIPOPAGO)) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_VALORRECIBO = 1 AND "VALORRECIBO" IS NULL) OR ("VALORRECIBO" = :Original_VALORRECIBO)) AND ((:IsNull_NOTA = 1 AND "NOTA" IS NULL) OR ("NOTA" = :Original_NOTA)) AND ((:IsNull_SUCURSAL = 1 AND "SUCURSAL" IS NULL) OR ("SUCURSAL" = :Original_SUCURSAL)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)) AND ((:IsNull_IDMEDIOPAGO = 1 AND "IDMEDIOPAGO" IS NULL) OR ("IDMEDIOPAGO" = :Original_IDMEDIOPAGO)) AND ((:IsNull_NUMEROMEDIO = 1 AND "NUMEROMEDIO" IS NULL) OR ("NUMEROMEDIO" = :Original_NUMEROMEDIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORRECIBO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRECIBO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="120" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMEDIOPAGO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROMEDIO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTERCERO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORRECIBO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORRECIBO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORRECIBO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRECIBO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA" Precision="0" ProviderType="Int32" Scale="0" Size="120" SourceColumn="NOTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="120" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMEDIOPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMEDIOPAGO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROMEDIO" Precision="0" ProviderType="NVarchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="IDTERCERO" DataSetColumn="IDTERCERO" />
              <Mapping SourceColumn="IDTIPOPAGO" DataSetColumn="IDTIPOPAGO" />
              <Mapping SourceColumn="FECHA" DataSetColumn="FECHA" />
              <Mapping SourceColumn="VALORRECIBO" DataSetColumn="VALORRECIBO" />
              <Mapping SourceColumn="NOTA" DataSetColumn="NOTA" />
              <Mapping SourceColumn="SUCURSAL" DataSetColumn="SUCURSAL" />
              <Mapping SourceColumn="IDCAJA" DataSetColumn="IDCAJA" />
              <Mapping SourceColumn="IDMEDIOPAGO" DataSetColumn="IDMEDIOPAGO" />
              <Mapping SourceColumn="NUMEROMEDIO" DataSetColumn="NUMEROMEDIO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOSCAJA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumento" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumento" GeneratorSourceName="FillByIdDocumento" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumento" UserSourceName="FillByIdDocumento">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FECHA, IDCAJA, IDDOCUMENTO, IDMEDIOPAGO, IDTERCERO, IDTIPOPAGO, NOTA, NUMERO, NUMEROMEDIO, SUCURSAL, VALORRECIBO FROM CAR_RECIBOSCAJA WHERE (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="SAMUEL.CAR_RECIBOSCAJA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.CAR_RECIBOSCAJA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="GetVrRecibosByFechasCaja" Modifier="Public" Name="GetVrRecibosByFechasCaja" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetVrRecibosByFechasCaja">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(VALORRECIBO) AS VRRECIBOS
FROM            CAR_RECIBOSCAJA
WHERE        (FECHA BETWEEN :PDESDEF AND :PHASTAF) AND (IDCAJA = :PIDCAJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHA" DataSourceName="SAMUEL.CAR_RECIBOSCAJA" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAF" ColumnName="FECHA" DataSourceName="SAMUEL.CAR_RECIBOSCAJA" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDCAJA" ColumnName="IDCAJA" DataSourceName="SAMUEL.CAR_RECIBOSCAJA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_RECIBOCAJADETALLEFACTURATableAdapter" GeneratorDataComponentClassName="CAR_RECIBOCAJADETALLEFACTURATableAdapter" Name="CAR_RECIBOCAJADETALLEFACTURA" UserDataComponentName="CAR_RECIBOCAJADETALLEFACTURATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOCAJADETALLEFACTURA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAR_RECIBOCAJADETALLEFACTURA" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDDOCFACTURA = 1 AND "IDDOCFACTURA" IS NULL) OR ("IDDOCFACTURA" = :Original_IDDOCFACTURA)) AND ((:IsNull_NUMEROFACTURA = 1 AND "NUMEROFACTURA" IS NULL) OR ("NUMEROFACTURA" = :Original_NUMEROFACTURA)) AND ((:IsNull_VALORPAGO = 1 AND "VALORPAGO" IS NULL) OR ("VALORPAGO" = :Original_VALORPAGO)) AND ("NITEM" = :Original_NITEM) AND ((:IsNull_IDCONCEPTOPAGO = 1 AND "IDCONCEPTOPAGO" IS NULL) OR ("IDCONCEPTOPAGO" = :Original_IDCONCEPTOPAGO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDDOCFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCONCEPTOPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCONCEPTOPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCONCEPTOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAR_RECIBOCAJADETALLEFACTURA" ("IDDOCUMENTO", "NUMERO", "IDDOCFACTURA", "NUMEROFACTURA", "VALORPAGO", "NITEM", "IDCONCEPTOPAGO") VALUES (:IDDOCUMENTO, :NUMERO, :IDDOCFACTURA, :NUMEROFACTURA, :VALORPAGO, :NITEM, :IDCONCEPTOPAGO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCONCEPTOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, IDDOCFACTURA, NUMEROFACTURA, VALORPAGO, NITEM, IDCONCEPTOPAGO FROM SAMUEL.CAR_RECIBOCAJADETALLEFACTURA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAR_RECIBOCAJADETALLEFACTURA" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "IDDOCFACTURA" = :IDDOCFACTURA, "NUMEROFACTURA" = :NUMEROFACTURA, "VALORPAGO" = :VALORPAGO, "NITEM" = :NITEM, "IDCONCEPTOPAGO" = :IDCONCEPTOPAGO WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_IDDOCFACTURA = 1 AND "IDDOCFACTURA" IS NULL) OR ("IDDOCFACTURA" = :Original_IDDOCFACTURA)) AND ((:IsNull_NUMEROFACTURA = 1 AND "NUMEROFACTURA" IS NULL) OR ("NUMEROFACTURA" = :Original_NUMEROFACTURA)) AND ((:IsNull_VALORPAGO = 1 AND "VALORPAGO" IS NULL) OR ("VALORPAGO" = :Original_VALORPAGO)) AND ("NITEM" = :Original_NITEM) AND ((:IsNull_IDCONCEPTOPAGO = 1 AND "IDCONCEPTOPAGO" IS NULL) OR ("IDCONCEPTOPAGO" = :Original_IDCONCEPTOPAGO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCONCEPTOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDDOCFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NITEM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NITEM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCONCEPTOPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCONCEPTOPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCONCEPTOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCONCEPTOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="IDDOCFACTURA" DataSetColumn="IDDOCFACTURA" />
              <Mapping SourceColumn="NUMEROFACTURA" DataSetColumn="NUMEROFACTURA" />
              <Mapping SourceColumn="VALORPAGO" DataSetColumn="VALORPAGO" />
              <Mapping SourceColumn="NITEM" DataSetColumn="NITEM" />
              <Mapping SourceColumn="IDCONCEPTOPAGO" DataSetColumn="IDCONCEPTOPAGO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOCAJADETALLEFACTURA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumento" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumento" GeneratorSourceName="FillByIdDocumento" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumento" UserSourceName="FillByIdDocumento">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDDOCUMENTO, NUMERO, IDCONCEPTOPAGO, IDDOCFACTURA, NUMEROFACTURA, VALORPAGO, NITEM
FROM         CAR_RECIBOCAJADETALLEFACTURA
WHERE     (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="SAMUEL.CAR_RECIBOCAJADETALLEFACTURA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.CAR_RECIBOCAJADETALLEFACTURA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CAR_RECIBOCAJAMEDIOPAGOTableAdapter" GeneratorDataComponentClassName="CAR_RECIBOCAJAMEDIOPAGOTableAdapter" Name="CAR_RECIBOCAJAMEDIOPAGO" UserDataComponentName="CAR_RECIBOCAJAMEDIOPAGOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOCAJAMEDIOPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CAR_RECIBOCAJAMEDIOPAGO" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("IDMEDIOPAGO" = :Original_IDMEDIOPAGO) AND ((:IsNull_NUMEROMEDIO = 1 AND "NUMEROMEDIO" IS NULL) OR ("NUMEROMEDIO" = :Original_NUMEROMEDIO)) AND ((:IsNull_VALORPAGO = 1 AND "VALORPAGO" IS NULL) OR ("VALORPAGO" = :Original_VALORPAGO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMEDIOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROMEDIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CAR_RECIBOCAJAMEDIOPAGO" ("IDDOCUMENTO", "NUMERO", "IDMEDIOPAGO", "NUMEROMEDIO", "VALORPAGO") VALUES (:IDDOCUMENTO, :NUMERO, :IDMEDIOPAGO, :NUMEROMEDIO, :VALORPAGO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMEDIOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROMEDIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, IDMEDIOPAGO, NUMEROMEDIO, VALORPAGO FROM SAMUEL.CAR_RECIBOCAJAMEDIOPAGO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CAR_RECIBOCAJAMEDIOPAGO" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "IDMEDIOPAGO" = :IDMEDIOPAGO, "NUMEROMEDIO" = :NUMEROMEDIO, "VALORPAGO" = :VALORPAGO WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("IDMEDIOPAGO" = :Original_IDMEDIOPAGO) AND ((:IsNull_NUMEROMEDIO = 1 AND "NUMEROMEDIO" IS NULL) OR ("NUMEROMEDIO" = :Original_NUMEROMEDIO)) AND ((:IsNull_VALORPAGO = 1 AND "VALORPAGO" IS NULL) OR ("VALORPAGO" = :Original_VALORPAGO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMEDIOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROMEDIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMEDIOPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMEDIOPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROMEDIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPAGO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="IDMEDIOPAGO" DataSetColumn="IDMEDIOPAGO" />
              <Mapping SourceColumn="NUMEROMEDIO" DataSetColumn="NUMEROMEDIO" />
              <Mapping SourceColumn="VALORPAGO" DataSetColumn="VALORPAGO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_RECIBOCAJAMEDIOPAGO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumentoNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumentoNumero" GeneratorSourceName="FillByIdDocumentoNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumentoNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumentoNumero" UserSourceName="FillByIdDocumentoNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, IDMEDIOPAGO, NUMEROMEDIO, VALORPAGO
FROM            CAR_RECIBOCAJAMEDIOPAGO
WHERE        (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="SAMUEL.CAR_RECIBOCAJAMEDIOPAGO" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.CAR_RECIBOCAJAMEDIOPAGO" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsCartera" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsCartera" msprop:Generator_DataSetName="dsCartera" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CAR_CONCEPTOPAGO" msprop:Generator_UserTableName="CAR_CONCEPTOPAGO" msprop:Generator_RowDeletedName="CAR_CONCEPTOPAGORowDeleted" msprop:Generator_RowChangedName="CAR_CONCEPTOPAGORowChanged" msprop:Generator_RowClassName="CAR_CONCEPTOPAGORow" msprop:Generator_RowChangingName="CAR_CONCEPTOPAGORowChanging" msprop:Generator_RowEvArgName="CAR_CONCEPTOPAGORowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_CONCEPTOPAGORowChangeEventHandler" msprop:Generator_TableClassName="CAR_CONCEPTOPAGODataTable" msprop:Generator_TableVarName="tableCAR_CONCEPTOPAGO" msprop:Generator_RowDeletingName="CAR_CONCEPTOPAGORowDeleting" msprop:Generator_TablePropName="CAR_CONCEPTOPAGO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCONCEPTO" msprop:Generator_UserColumnName="IDCONCEPTO" msprop:Generator_ColumnPropNameInRow="IDCONCEPTO" msprop:Generator_ColumnVarNameInTable="columnIDCONCEPTO" msprop:Generator_ColumnPropNameInTable="IDCONCEPTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSUBCLASE" msprop:Generator_UserColumnName="IDSUBCLASE" msprop:Generator_ColumnPropNameInRow="IDSUBCLASE" msprop:Generator_ColumnVarNameInTable="columnIDSUBCLASE" msprop:Generator_ColumnPropNameInTable="IDSUBCLASEColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_CARTERA" msprop:Generator_UserTableName="CAR_CARTERA" msprop:Generator_RowDeletedName="CAR_CARTERARowDeleted" msprop:Generator_RowChangedName="CAR_CARTERARowChanged" msprop:Generator_RowClassName="CAR_CARTERARow" msprop:Generator_RowChangingName="CAR_CARTERARowChanging" msprop:Generator_RowEvArgName="CAR_CARTERARowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_CARTERARowChangeEventHandler" msprop:Generator_TableClassName="CAR_CARTERADataTable" msprop:Generator_TableVarName="tableCAR_CARTERA" msprop:Generator_RowDeletingName="CAR_CARTERARowDeleting" msprop:Generator_TablePropName="CAR_CARTERA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCLIENTE" msprop:Generator_UserColumnName="IDCLIENTE" msprop:Generator_ColumnPropNameInRow="IDCLIENTE" msprop:Generator_ColumnVarNameInTable="columnIDCLIENTE" msprop:Generator_ColumnPropNameInTable="IDCLIENTEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PERIODO" msprop:Generator_UserColumnName="PERIODO" msprop:Generator_ColumnPropNameInRow="PERIODO" msprop:Generator_ColumnVarNameInTable="columnPERIODO" msprop:Generator_ColumnPropNameInTable="PERIODOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COMPRAS" msprop:Generator_UserColumnName="COMPRAS" msprop:Generator_ColumnPropNameInRow="COMPRAS" msprop:Generator_ColumnVarNameInTable="columnCOMPRAS" msprop:Generator_ColumnPropNameInTable="COMPRASColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DEVOLUCIONES" msprop:Generator_UserColumnName="DEVOLUCIONES" msprop:Generator_ColumnPropNameInRow="DEVOLUCIONES" msprop:Generator_ColumnVarNameInTable="columnDEVOLUCIONES" msprop:Generator_ColumnPropNameInTable="DEVOLUCIONESColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PAGOS" msprop:Generator_UserColumnName="PAGOS" msprop:Generator_ColumnPropNameInRow="PAGOS" msprop:Generator_ColumnVarNameInTable="columnPAGOS" msprop:Generator_ColumnPropNameInTable="PAGOSColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SALDOINICIAL" msprop:Generator_UserColumnName="SALDOINICIAL" msprop:Generator_ColumnPropNameInRow="SALDOINICIAL" msprop:Generator_ColumnVarNameInTable="columnSALDOINICIAL" msprop:Generator_ColumnPropNameInTable="SALDOINICIALColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_TIPOPAGO" msprop:Generator_UserTableName="CAR_TIPOPAGO" msprop:Generator_RowDeletedName="CAR_TIPOPAGORowDeleted" msprop:Generator_RowChangedName="CAR_TIPOPAGORowChanged" msprop:Generator_RowClassName="CAR_TIPOPAGORow" msprop:Generator_RowChangingName="CAR_TIPOPAGORowChanging" msprop:Generator_RowEvArgName="CAR_TIPOPAGORowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_TIPOPAGORowChangeEventHandler" msprop:Generator_TableClassName="CAR_TIPOPAGODataTable" msprop:Generator_TableVarName="tableCAR_TIPOPAGO" msprop:Generator_RowDeletingName="CAR_TIPOPAGORowDeleting" msprop:Generator_TablePropName="CAR_TIPOPAGO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTIPOPAGO" msprop:Generator_UserColumnName="IDTIPOPAGO" msprop:Generator_ColumnPropNameInRow="IDTIPOPAGO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPAGO" msprop:Generator_ColumnPropNameInTable="IDTIPOPAGOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_FORMASPAGO" msprop:Generator_UserTableName="CAR_FORMASPAGO" msprop:Generator_RowDeletedName="CAR_FORMASPAGORowDeleted" msprop:Generator_RowChangedName="CAR_FORMASPAGORowChanged" msprop:Generator_RowClassName="CAR_FORMASPAGORow" msprop:Generator_RowChangingName="CAR_FORMASPAGORowChanging" msprop:Generator_RowEvArgName="CAR_FORMASPAGORowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_FORMASPAGORowChangeEventHandler" msprop:Generator_TableClassName="CAR_FORMASPAGODataTable" msprop:Generator_TableVarName="tableCAR_FORMASPAGO" msprop:Generator_RowDeletingName="CAR_FORMASPAGORowDeleting" msprop:Generator_TablePropName="CAR_FORMASPAGO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDFORMAPAGO" msprop:Generator_UserColumnName="IDFORMAPAGO" msprop:Generator_ColumnPropNameInRow="IDFORMAPAGO" msprop:Generator_ColumnVarNameInTable="columnIDFORMAPAGO" msprop:Generator_ColumnPropNameInTable="IDFORMAPAGOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NDIAS" msprop:Generator_UserColumnName="NDIAS" msprop:Generator_ColumnPropNameInRow="NDIAS" msprop:Generator_ColumnVarNameInTable="columnNDIAS" msprop:Generator_ColumnPropNameInTable="NDIASColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DESCUENTO" msprop:Generator_UserColumnName="DESCUENTO" msprop:Generator_ColumnPropNameInRow="DESCUENTO" msprop:Generator_ColumnVarNameInTable="columnDESCUENTO" msprop:Generator_ColumnPropNameInTable="DESCUENTOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_RECIBOCAJADETALLEPLAN" msprop:Generator_UserTableName="CAR_RECIBOCAJADETALLEPLAN" msprop:Generator_RowDeletedName="CAR_RECIBOCAJADETALLEPLANRowDeleted" msprop:Generator_RowChangedName="CAR_RECIBOCAJADETALLEPLANRowChanged" msprop:Generator_RowClassName="CAR_RECIBOCAJADETALLEPLANRow" msprop:Generator_RowChangingName="CAR_RECIBOCAJADETALLEPLANRowChanging" msprop:Generator_RowEvArgName="CAR_RECIBOCAJADETALLEPLANRowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_RECIBOCAJADETALLEPLANRowChangeEventHandler" msprop:Generator_TableClassName="CAR_RECIBOCAJADETALLEPLANDataTable" msprop:Generator_TableVarName="tableCAR_RECIBOCAJADETALLEPLAN" msprop:Generator_RowDeletingName="CAR_RECIBOCAJADETALLEPLANRowDeleting" msprop:Generator_TablePropName="CAR_RECIBOCAJADETALLEPLAN">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="IDPLAN" msprop:Generator_UserColumnName="IDPLAN" msprop:Generator_ColumnPropNameInRow="IDPLAN" msprop:Generator_ColumnVarNameInTable="columnIDPLAN" msprop:Generator_ColumnPropNameInTable="IDPLANColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALORPLAN" msprop:Generator_UserColumnName="VALORPLAN" msprop:Generator_ColumnPropNameInRow="VALORPLAN" msprop:Generator_ColumnVarNameInTable="columnVALORPLAN" msprop:Generator_ColumnPropNameInTable="VALORPLANColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IMEI" msprop:Generator_UserColumnName="IMEI" msprop:Generator_ColumnPropNameInRow="IMEI" msprop:Generator_ColumnVarNameInTable="columnIMEI" msprop:Generator_ColumnPropNameInTable="IMEIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ICCID" msprop:Generator_UserColumnName="ICCID" msprop:Generator_ColumnPropNameInRow="ICCID" msprop:Generator_ColumnVarNameInTable="columnICCID" msprop:Generator_ColumnPropNameInTable="ICCIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MIN" msprop:Generator_UserColumnName="MIN" msprop:Generator_ColumnPropNameInRow="MIN" msprop:Generator_ColumnVarNameInTable="columnMIN" msprop:Generator_ColumnPropNameInTable="MINColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NITEM" msprop:Generator_UserColumnName="NITEM" msprop:Generator_ColumnPropNameInRow="NITEM" msprop:Generator_ColumnVarNameInTable="columnNITEM" msprop:Generator_ColumnPropNameInTable="NITEMColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_RECIBOSCAJA" msprop:Generator_UserTableName="CAR_RECIBOSCAJA" msprop:Generator_RowDeletedName="CAR_RECIBOSCAJARowDeleted" msprop:Generator_RowChangedName="CAR_RECIBOSCAJARowChanged" msprop:Generator_RowClassName="CAR_RECIBOSCAJARow" msprop:Generator_RowChangingName="CAR_RECIBOSCAJARowChanging" msprop:Generator_RowEvArgName="CAR_RECIBOSCAJARowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_RECIBOSCAJARowChangeEventHandler" msprop:Generator_TableClassName="CAR_RECIBOSCAJADataTable" msprop:Generator_TableVarName="tableCAR_RECIBOSCAJA" msprop:Generator_RowDeletingName="CAR_RECIBOSCAJARowDeleting" msprop:Generator_TablePropName="CAR_RECIBOSCAJA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="IDTERCERO" msprop:Generator_UserColumnName="IDTERCERO" msprop:Generator_ColumnPropNameInRow="IDTERCERO" msprop:Generator_ColumnVarNameInTable="columnIDTERCERO" msprop:Generator_ColumnPropNameInTable="IDTERCEROColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPOPAGO" msprop:Generator_UserColumnName="IDTIPOPAGO" msprop:Generator_ColumnPropNameInRow="IDTIPOPAGO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPAGO" msprop:Generator_ColumnPropNameInTable="IDTIPOPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FECHA" msprop:Generator_UserColumnName="FECHA" msprop:Generator_ColumnPropNameInRow="FECHA" msprop:Generator_ColumnVarNameInTable="columnFECHA" msprop:Generator_ColumnPropNameInTable="FECHAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VALORRECIBO" msprop:Generator_UserColumnName="VALORRECIBO" msprop:Generator_ColumnPropNameInRow="VALORRECIBO" msprop:Generator_ColumnVarNameInTable="columnVALORRECIBO" msprop:Generator_ColumnPropNameInTable="VALORRECIBOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NOTA" msprop:Generator_UserColumnName="NOTA" msprop:Generator_ColumnPropNameInRow="NOTA" msprop:Generator_ColumnVarNameInTable="columnNOTA" msprop:Generator_ColumnPropNameInTable="NOTAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUCURSAL" msprop:Generator_UserColumnName="SUCURSAL" msprop:Generator_ColumnPropNameInRow="SUCURSAL" msprop:Generator_ColumnVarNameInTable="columnSUCURSAL" msprop:Generator_ColumnPropNameInTable="SUCURSALColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IDCAJA" msprop:Generator_UserColumnName="IDCAJA" msprop:Generator_ColumnVarNameInTable="columnIDCAJA" msprop:Generator_ColumnPropNameInRow="IDCAJA" msprop:Generator_ColumnPropNameInTable="IDCAJAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDMEDIOPAGO" msprop:Generator_UserColumnName="IDMEDIOPAGO" msprop:Generator_ColumnPropNameInRow="IDMEDIOPAGO" msprop:Generator_ColumnVarNameInTable="columnIDMEDIOPAGO" msprop:Generator_ColumnPropNameInTable="IDMEDIOPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROMEDIO" msprop:Generator_UserColumnName="NUMEROMEDIO" msprop:Generator_ColumnPropNameInRow="NUMEROMEDIO" msprop:Generator_ColumnVarNameInTable="columnNUMEROMEDIO" msprop:Generator_ColumnPropNameInTable="NUMEROMEDIOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_RECIBOCAJADETALLEFACTURA" msprop:Generator_UserTableName="CAR_RECIBOCAJADETALLEFACTURA" msprop:Generator_RowDeletedName="CAR_RECIBOCAJADETALLEFACTURARowDeleted" msprop:Generator_RowChangedName="CAR_RECIBOCAJADETALLEFACTURARowChanged" msprop:Generator_RowClassName="CAR_RECIBOCAJADETALLEFACTURARow" msprop:Generator_RowChangingName="CAR_RECIBOCAJADETALLEFACTURARowChanging" msprop:Generator_RowEvArgName="CAR_RECIBOCAJADETALLEFACTURARowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_RECIBOCAJADETALLEFACTURARowChangeEventHandler" msprop:Generator_TableClassName="CAR_RECIBOCAJADETALLEFACTURADataTable" msprop:Generator_TableVarName="tableCAR_RECIBOCAJADETALLEFACTURA" msprop:Generator_RowDeletingName="CAR_RECIBOCAJADETALLEFACTURARowDeleting" msprop:Generator_TablePropName="CAR_RECIBOCAJADETALLEFACTURA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="IDDOCFACTURA" msprop:Generator_UserColumnName="IDDOCFACTURA" msprop:Generator_ColumnPropNameInRow="IDDOCFACTURA" msprop:Generator_ColumnVarNameInTable="columnIDDOCFACTURA" msprop:Generator_ColumnPropNameInTable="IDDOCFACTURAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROFACTURA" msprop:Generator_UserColumnName="NUMEROFACTURA" msprop:Generator_ColumnPropNameInRow="NUMEROFACTURA" msprop:Generator_ColumnVarNameInTable="columnNUMEROFACTURA" msprop:Generator_ColumnPropNameInTable="NUMEROFACTURAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORPAGO" msprop:Generator_UserColumnName="VALORPAGO" msprop:Generator_ColumnPropNameInRow="VALORPAGO" msprop:Generator_ColumnVarNameInTable="columnVALORPAGO" msprop:Generator_ColumnPropNameInTable="VALORPAGOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NITEM" msprop:Generator_UserColumnName="NITEM" msprop:Generator_ColumnPropNameInRow="NITEM" msprop:Generator_ColumnVarNameInTable="columnNITEM" msprop:Generator_ColumnPropNameInTable="NITEMColumn" type="xs:decimal" />
              <xs:element name="IDCONCEPTOPAGO" msprop:Generator_UserColumnName="IDCONCEPTOPAGO" msprop:Generator_ColumnPropNameInRow="IDCONCEPTOPAGO" msprop:Generator_ColumnVarNameInTable="columnIDCONCEPTOPAGO" msprop:Generator_ColumnPropNameInTable="IDCONCEPTOPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CAR_RECIBOCAJAMEDIOPAGO" msprop:Generator_UserTableName="CAR_RECIBOCAJAMEDIOPAGO" msprop:Generator_RowDeletedName="CAR_RECIBOCAJAMEDIOPAGORowDeleted" msprop:Generator_RowChangedName="CAR_RECIBOCAJAMEDIOPAGORowChanged" msprop:Generator_RowClassName="CAR_RECIBOCAJAMEDIOPAGORow" msprop:Generator_RowChangingName="CAR_RECIBOCAJAMEDIOPAGORowChanging" msprop:Generator_RowEvArgName="CAR_RECIBOCAJAMEDIOPAGORowChangeEvent" msprop:Generator_RowEvHandlerName="CAR_RECIBOCAJAMEDIOPAGORowChangeEventHandler" msprop:Generator_TableClassName="CAR_RECIBOCAJAMEDIOPAGODataTable" msprop:Generator_TableVarName="tableCAR_RECIBOCAJAMEDIOPAGO" msprop:Generator_RowDeletingName="CAR_RECIBOCAJAMEDIOPAGORowDeleting" msprop:Generator_TablePropName="CAR_RECIBOCAJAMEDIOPAGO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="IDMEDIOPAGO" msprop:Generator_UserColumnName="IDMEDIOPAGO" msprop:Generator_ColumnVarNameInTable="columnIDMEDIOPAGO" msprop:Generator_ColumnPropNameInRow="IDMEDIOPAGO" msprop:Generator_ColumnPropNameInTable="IDMEDIOPAGOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROMEDIO" msprop:Generator_UserColumnName="NUMEROMEDIO" msprop:Generator_ColumnVarNameInTable="columnNUMEROMEDIO" msprop:Generator_ColumnPropNameInRow="NUMEROMEDIO" msprop:Generator_ColumnPropNameInTable="NUMEROMEDIOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALORPAGO" msprop:Generator_UserColumnName="VALORPAGO" msprop:Generator_ColumnVarNameInTable="columnVALORPAGO" msprop:Generator_ColumnPropNameInRow="VALORPAGO" msprop:Generator_ColumnPropNameInTable="VALORPAGOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_CONCEPTOPAGO" />
      <xs:field xpath="mstns:IDCONCEPTO" />
    </xs:unique>
    <xs:unique name="CAR_CARTERA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_CARTERA" />
      <xs:field xpath="mstns:IDCLIENTE" />
      <xs:field xpath="mstns:PERIODO" />
    </xs:unique>
    <xs:unique name="CAR_TIPOPAGO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_TIPOPAGO" />
      <xs:field xpath="mstns:IDTIPOPAGO" />
    </xs:unique>
    <xs:unique name="CAR_FORMASPAGO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_FORMASPAGO" />
      <xs:field xpath="mstns:IDFORMAPAGO" />
    </xs:unique>
    <xs:unique name="CAR_RECIBOCAJADETALLEPLAN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_RECIBOCAJADETALLEPLAN" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NITEM" />
    </xs:unique>
    <xs:unique name="CAR_RECIBOSCAJA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_RECIBOSCAJA" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:unique>
    <xs:unique name="CAR_RECIBOCAJADETALLEFACTURA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_RECIBOCAJADETALLEFACTURA" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NITEM" />
    </xs:unique>
    <xs:unique name="CAR_RECIBOCAJAMEDIOPAGO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CAR_RECIBOCAJAMEDIOPAGO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:IDMEDIOPAGO" />
    </xs:unique>
    <xs:keyref name="FK_MEDIOPAGO_RECIBOCAJA" refer="CAR_RECIBOSCAJA_Constraint1" msprop:rel_Generator_UserRelationName="FK_MEDIOPAGO_RECIBOCAJA" msprop:rel_Generator_RelationVarName="relationFK_MEDIOPAGO_RECIBOCAJA" msprop:rel_Generator_UserChildTable="CAR_RECIBOCAJAMEDIOPAGO" msprop:rel_Generator_UserParentTable="CAR_RECIBOSCAJA" msprop:rel_Generator_ParentPropName="CAR_RECIBOSCAJARowParent" msprop:rel_Generator_ChildPropName="GetCAR_RECIBOCAJAMEDIOPAGORows">
      <xs:selector xpath=".//mstns:CAR_RECIBOCAJAMEDIOPAGO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:keyref>
    <xs:keyref name="FK_CAR_RECIBOSCAJA_CAR_RECIBOCAJADETALLEFACTURA" refer="CAR_RECIBOSCAJA_Constraint1" msprop:rel_Generator_UserRelationName="FK_CAR_RECIBOSCAJA_CAR_RECIBOCAJADETALLEFACTURA" msprop:rel_Generator_RelationVarName="relationFK_CAR_RECIBOSCAJA_CAR_RECIBOCAJADETALLEFACTURA" msprop:rel_Generator_UserChildTable="CAR_RECIBOCAJADETALLEFACTURA" msprop:rel_Generator_UserParentTable="CAR_RECIBOSCAJA" msprop:rel_Generator_ParentPropName="CAR_RECIBOSCAJARowParent" msprop:rel_Generator_ChildPropName="GetCAR_RECIBOCAJADETALLEFACTURARows">
      <xs:selector xpath=".//mstns:CAR_RECIBOCAJADETALLEFACTURA" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:keyref>
    <xs:keyref name="FK_CAR_RECIBOSCAJA_CAR_RECIBOCAJADETALLEPLAN" refer="CAR_RECIBOSCAJA_Constraint1" msprop:rel_Generator_UserRelationName="FK_CAR_RECIBOSCAJA_CAR_RECIBOCAJADETALLEPLAN" msprop:rel_Generator_RelationVarName="relationFK_CAR_RECIBOSCAJA_CAR_RECIBOCAJADETALLEPLAN" msprop:rel_Generator_UserChildTable="CAR_RECIBOCAJADETALLEPLAN" msprop:rel_Generator_UserParentTable="CAR_RECIBOSCAJA" msprop:rel_Generator_ParentPropName="CAR_RECIBOSCAJARowParent" msprop:rel_Generator_ChildPropName="GetCAR_RECIBOCAJADETALLEPLANRows">
      <xs:selector xpath=".//mstns:CAR_RECIBOCAJADETALLEPLAN" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_RECIBOSCAJA_TIPOPAGO" msdata:parent="CAR_TIPOPAGO" msdata:child="CAR_RECIBOSCAJA" msdata:parentkey="IDTIPOPAGO" msdata:childkey="IDTIPOPAGO" msprop:Generator_UserRelationName="FK_RECIBOSCAJA_TIPOPAGO" msprop:Generator_RelationVarName="relationFK_RECIBOSCAJA_TIPOPAGO" msprop:Generator_UserChildTable="CAR_RECIBOSCAJA" msprop:Generator_UserParentTable="CAR_TIPOPAGO" msprop:Generator_ParentPropName="CAR_TIPOPAGORow" msprop:Generator_ChildPropName="GetCAR_RECIBOSCAJARows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>